<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<html lang="zh-cn" xml:lang="zh-cn">
 <head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="DC.Type" content="topic">
  <meta name="DC.Title" content="步骤3：注册SQL Server数据库">
  <meta name="product" content="">
  <meta name="DC.Relation" scheme="URI" content="zh-cn_topic_0000001839245581.html">
  <meta name="prodname" content="">
  <meta name="version" content="">
  <meta name="brand" content="30-OceanProtect 备份一体机 1.5.0-1.6.0 帮助中心">
  <meta name="DC.Publisher" content="20240320">
  <meta name="DC.Format" content="XHTML">
  <meta name="DC.Identifier" content="ZH-CN_TOPIC_0000001792526314">
  <meta name="DC.Language" content="zh-cn">
  <link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
  <title>步骤3：注册SQL Server数据库</title>
 </head>
 <body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px">
  <a name="ZH-CN_TOPIC_0000001792526314"></a><a name="ZH-CN_TOPIC_0000001792526314"></a>
  <h1 class="topictitle1">步骤3：注册SQL Server数据库</h1>
  <div>
   <p>当SQL Server数据库所在主机安装ProtectAgent后，<span>本产品</span>会自动发现SQL Server数据库主机，您需要在管理界面注册数据库，以对其进行保护。</p>
   <div class="section">
    <h4 class="sectiontitle">背景信息</h4>
    <p>要备份或恢复数据库，<span>本产品</span>需要添加数据库的登录凭据。支持两种认证方式：<span>Windows身份验证</span>、<span>SQL Server身份认证</span>。</p>
    <ul>
     <li>当数据库已开启<span>Windows身份验证</span>，则<span>本产品</span>自动注册SQL Server数据库，管理界面上自动显示数据库的认证状态为“已认证”。</li>
     <li>当管理界面显示为<span class="uicontrol">“<span>未认证</span>”</span>时，表示新注册的数据库认证方式为<span class="uicontrol">“<span>数据库认证</span>”</span>，需要您输入认证信息进行认证。</li>
    </ul>
   </div>
   <div class="section">
    <h4 class="sectiontitle">注册SQL Server单实例</h4>
    <ol>
     <li><span>选择<span class="uicontrol" id="ZH-CN_TOPIC_0000001792526314__zh-cn_topic_0000001839142377_uicontrol114088356363">“<span id="ZH-CN_TOPIC_0000001792526314__zh-cn_topic_0000001839142377_text1840913533616">保护</span> &gt; 数据库 &gt; SQL Server”</span>。</span></li>
     <li><span>选择<span class="uicontrol">“<span>实例</span>”</span>页签。</span></li>
     <li><span>单击<span class="uicontrol">“<span>注册</span>”</span>，注册SQL Server。</span></li>
     <li><span><span class="uicontrol">“<span>类型</span>”</span>选择<span class="uicontrol">“<span>单实例</span>”</span>。</span></li>
     <li><span>配置数据库实例及其认证信息。</span><p></p><p>相关参数说明如<a href="#ZH-CN_TOPIC_0000001792526314__zh-cn_topic_0000001311214069_table241515964115">表1</a>所示。</p>
      <div class="tablenoborder">
       <a name="ZH-CN_TOPIC_0000001792526314__zh-cn_topic_0000001311214069_table241515964115"></a><a name="zh-cn_topic_0000001311214069_table241515964115"></a>
       <table cellpadding="4" cellspacing="0" summary="" id="ZH-CN_TOPIC_0000001792526314__zh-cn_topic_0000001311214069_table241515964115" frame="border" border="1" rules="all">
        <caption>
         <b>表1 </b>SQL Server单实例注册信息
        </caption>
        <colgroup>
         <col style="width:48.18%">
         <col style="width:51.82%">
        </colgroup>
        <thead align="left">
         <tr>
          <th align="left" class="cellrowborder" valign="top" width="48.18%" id="mcps1.3.3.2.5.2.2.2.3.1.1"><p>参数</p></th>
          <th align="left" class="cellrowborder" valign="top" width="51.82%" id="mcps1.3.3.2.5.2.2.2.3.1.2"><p>说明</p></th>
         </tr>
        </thead>
        <tbody>
         <tr>
          <td class="cellrowborder" valign="top" width="48.18%" headers="mcps1.3.3.2.5.2.2.2.3.1.1 "><p id="ZH-CN_TOPIC_0000001792526314__p157991143121110">SQL Server网络名称</p></td>
          <td class="cellrowborder" valign="top" width="51.82%" headers="mcps1.3.3.2.5.2.2.2.3.1.2 "><p id="ZH-CN_TOPIC_0000001792526314__p1579919436116">SQL Server的网络名称，默认为主机名称。</p></td>
         </tr>
         <tr>
          <td class="cellrowborder" valign="top" width="48.18%" headers="mcps1.3.3.2.5.2.2.2.3.1.1 "><p id="ZH-CN_TOPIC_0000001792526314__zh-cn_topic_0000001311214069_p0414115904113">命名实例</p></td>
          <td class="cellrowborder" valign="top" width="51.82%" headers="mcps1.3.3.2.5.2.2.2.3.1.2 "><p>实例名称。</p></td>
         </tr>
         <tr>
          <td class="cellrowborder" valign="top" width="48.18%" headers="mcps1.3.3.2.5.2.2.2.3.1.1 "><p><span>主机</span></p></td>
          <td class="cellrowborder" valign="top" width="51.82%" headers="mcps1.3.3.2.5.2.2.2.3.1.2 "><p>选择要注册的数据库主机。</p></td>
         </tr>
         <tr>
          <td class="cellrowborder" valign="top" width="48.18%" headers="mcps1.3.3.2.5.2.2.2.3.1.1 "><p><span>认证方式</span></p></td>
          <td class="cellrowborder" valign="top" width="51.82%" headers="mcps1.3.3.2.5.2.2.2.3.1.2 "><p>实例认证方式支持OS认证和数据库认证。</p></td>
         </tr>
         <tr>
          <td class="cellrowborder" valign="top" width="48.18%" headers="mcps1.3.3.2.5.2.2.2.3.1.1 "><p><span>数据库用户名</span></p></td>
          <td class="cellrowborder" valign="top" width="51.82%" headers="mcps1.3.3.2.5.2.2.2.3.1.2 "><p>数据库的管理员用户名称</p></td>
         </tr>
         <tr>
          <td class="cellrowborder" valign="top" width="48.18%" headers="mcps1.3.3.2.5.2.2.2.3.1.1 "><p><span>数据库密码</span></p></td>
          <td class="cellrowborder" valign="top" width="51.82%" headers="mcps1.3.3.2.5.2.2.2.3.1.2 "><p>数据库管理员用户的密码</p></td>
         </tr>
        </tbody>
       </table>
      </div> <p></p></li>
     <li><span>单击<span class="uicontrol">“确定”</span>。</span></li>
    </ol>
   </div>
   <div class="section">
    <h4 class="sectiontitle">注册SQL Server集群实例</h4>
    <p><strong>前提条件</strong></p>
    <div class="p">
     注册SQL Server集群实例前，请确保集群中每个数据库主机已进行注册。
     <div class="note">
      <img src="public_sys-resources/note_3.0-zh-cn.png"><span class="notetitle"> </span>
      <div class="notebody">
       <p>要求集群中所有主机已注册的数据库名称相同。</p>
      </div>
     </div>
    </div>
    <p><strong>操作步骤</strong></p>
    <ol>
     <li><span>创建集群。</span><p></p>
      <ol type="a">
       <li>在SQL Server页面选择<span class="uicontrol">“<span>集群</span>”</span>页签。</li>
       <li>单击<span class="uicontrol">“<span>注册</span>”</span>。</li>
       <li>在<span class="uicontrol">“<span>注册</span>”</span>页面，自定义集群名称，并选择集群节点。</li>
       <li>单击<span class="uicontrol">“确定”</span>。</li>
      </ol> <p></p></li>
     <li><span>注册集群实例。</span><p></p>
      <ol type="a">
       <li>在SQL Server页面选择<span class="uicontrol">“<span>实例</span>”</span>页签。</li>
       <li>单击<span class="uicontrol">“<span>注册</span>”</span>。</li>
       <li><span class="uicontrol">“<span>类型</span>”</span>选择<span class="uicontrol">“<span>集群实例</span>”</span>。</li>
       <li>配置数据库实例及其认证信息。<p>相关参数说明如<a href="#ZH-CN_TOPIC_0000001792526314__table163871610417">表2</a>所示。</p>
        <div class="tablenoborder">
         <a name="ZH-CN_TOPIC_0000001792526314__table163871610417"></a><a name="table163871610417"></a>
         <table cellpadding="4" cellspacing="0" summary="" id="ZH-CN_TOPIC_0000001792526314__table163871610417" frame="border" border="1" rules="all">
          <caption>
           <b>表2 </b>SQL Server集群实例注册信息
          </caption>
          <colgroup>
           <col style="width:25.629999999999995%">
           <col style="width:74.37%">
          </colgroup>
          <thead align="left">
           <tr>
            <th align="left" class="cellrowborder" valign="top" width="25.629999999999995%" id="mcps1.3.4.5.2.2.1.4.2.2.3.1.1"><p>参数</p></th>
            <th align="left" class="cellrowborder" valign="top" width="74.37%" id="mcps1.3.4.5.2.2.1.4.2.2.3.1.2"><p>说明</p></th>
           </tr>
          </thead>
          <tbody>
           <tr>
            <td class="cellrowborder" valign="top" width="25.629999999999995%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.1 "><p>SQL Server网络名称</p></td>
            <td class="cellrowborder" valign="top" width="74.37%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.2 "><p>SQL Server的网络名称，默认为主机名称。</p> <p>WSFC集群的SQL Server网络名称为创建集群时自定义名称。</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.629999999999995%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.1 "><p>命名实例</p></td>
            <td class="cellrowborder" valign="top" width="74.37%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.2 "><p>集群实例名称。</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.629999999999995%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.1 "><p><span>集群</span></p></td>
            <td class="cellrowborder" valign="top" width="74.37%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.2 "><p>选择要注册的数据库集群。</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.629999999999995%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.1 "><p><span>节点</span></p></td>
            <td class="cellrowborder" valign="top" width="74.37%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.2 "><p>数据库实例所在的主机。</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.629999999999995%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.1 "><p><span>认证方式</span></p></td>
            <td class="cellrowborder" valign="top" width="74.37%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.2 "><p>集群实例认证方式支持OS认证和数据库认证。</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.629999999999995%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.1 "><p><span>数据库用户名</span></p></td>
            <td class="cellrowborder" valign="top" width="74.37%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.2 "><p>数据库的管理员用户名称</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.629999999999995%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.1 "><p><span>数据库密码</span></p></td>
            <td class="cellrowborder" valign="top" width="74.37%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.2 "><p>数据库管理员用户的密码</p></td>
           </tr>
          </tbody>
         </table>
        </div></li>
       <li>单击<span class="uicontrol">“确定”</span>。</li>
      </ol> <p></p></li>
    </ol>
   </div>
   <div class="section">
    <h4 class="sectiontitle">相关操作</h4>
    <ul>
     <li>若集群类型为WSFC集群时，选择节点时需要选择所有节点。<p><span><img src="zh-cn_image_0000001920064725.png"></span></p></li>
     <li>若集群类型为可用性组时，需要逐个注册集群实例。<p><span><img src="zh-cn_image_0000001874065564.png"></span></p></li>
    </ul>
   </div>
  </div>
  <div>
   <div class="familylinks">
    <div class="parentlink">
     <strong>父主题：</strong> <a href="zh-cn_topic_0000001839245581.html">备份SQL Server数据库</a>
    </div>
   </div>
  </div>
 </body>
</html>